<?php
class M_DbTable_TourHotelPrice extends Apps_Db_Table_Abstract {
	protected $_name = 'tour_hotel_price';

	const STATUS_ACTIVE 	= 1;
	const STATUS_INACTIVE 	= 0;
	const STATUS_DELETED 	= -1;
	
	public function listTourHotelPriceByTourHotelId($tourHotelId) {
		$q = $this->_db
				  ->select()
				  ->from($this->_name)
				  ->join('tour_hotel', 'tour_hotel.id = '. $this->_name . '.tour_hotel_id', null)
				  ->where($this->_name . '.tour_hotel_id =? ', $tourHotelId)
				  ->order('tour_hotel.hotel_rating');
		return $q;
	}

}